/****** Object:  StoredProcedure [dbo].[CustOrdersOrders]    Script Date: 06/12/2011 01:42:54 ******/
DROP PROCEDURE [dbo].[CustOrdersOrders]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[CustOrdersOrders] @CustomerID nchar(5)
AS
SELECT OrderID, 
	OrderDate,
	RequiredDate,
	ShippedDate
FROM Orders
WHERE CustomerID = @CustomerID
ORDER BY OrderID
GO
